Labels:book | chat room | hakham | sky OCR: 638 SECTION CHAPTER 11 If customer information and order information are grouped in the same table, each time Jorge Rodriguez places an order, his name, shipping address, billing address, telephone number, and e-mail address must be entered and stored. This data redundancy not only requires extra storage space, but also could lead to storing inconsistent or inaccurate data The solution to create separate tables for Orders and Customers, which can be related by including CustomerNumber field in both tables, as shown ir Figure 11-38. CUST TOMERS ORDERS FIGURE 11-38 CustomerNumber OrderNumber Fields for each order are sepa- FirstName Cus tomerNumber rated into two tables- -one for LastName TotalPrice customer information and one Street OrderDate for order information City Qty State Cat# ZipCo ...
